database snapshot

produces native-mode bulk copy program output of all tables from a database snapshot.

从数据库快照生成所有表的本机模式大容量复制程序输出。

互联网摘选

You can then leverage the database snapshot to identify the sort activities at the database level

然后，您可以利用数据库快照来确定数据库层的排序活动

互联网摘选

Unlike a regular backup set, the database snapshot is an incomplete copy of the database files.

与定期备份集不同，数据库快照并非数据库文件的完整副本。

provided by jukuu

Is the name of the new database snapshot.

新数据库快照的名称。

provided by jukuu

Because a database snapshot is read-only, a log file cannot be specified.

由于数据库快照是只读的，所以不能指定日志文件。

provided by jukuu

for a database snapshot, size reflects the maximum space that the snapshot can ever use for the file.

对于数据库快照来说，size表示该快照可以一直用于文件的最大空间。

互联网摘选

Added information about clearing the plan cache to the "dropping a database snapshot" section.

在“删除数据库快照”部分添加了有关清除计划缓存的信息。

provided by jukuu

You cannot change any of the specifications of the database snapshot files.

不能更改数据库快照文件的任何规范。

provided by jukuu

The following are the most pertinent lines in the database snapshot

以下是数据库快照中最相关的几行

互联网摘选

To use a database snapshot, clients need to know where to find it.

若要使用数据库快照，客户端需要知道它的位置。

provided by jukuu

A database snapshot captures the point in time at which snapshot creation began, minus any uncommitted transactions.

数据库快照捕获开始创建快照的时间点，去掉所有未提交的事务。

provided by jukuu

A database snapshot records the current state of the data in a database as if all active transactions were rolled back.

数据库快照记录数据库中数据的当前状态，就好像所有的活动事务都已回滚一样。

provided by jukuu

The database snapshot monitor can be used to determine the number of transactions performed per second, as follows

数据库快照监控器可以用于确定每秒所执行的事务数目，如下

互联网摘选

Identify the database snapshot that you want to drop.

标识要删除的数据库快照。

provided by jukuu

Before the snapshot becomes available, the open transactions are rolled back to make the database snapshot transactionally consistent.

在快照可以使用之前，打开的事务会回滚以使数据库快照在事务上取得一致。

provided by jukuu

Clarified the database snapshot restriction for offline files.

澄清了离线文件的数据库快照限制。

provided by jukuu

Corrected technical error to clarify that you cannot bring a filegroup online when a database snapshot exists.

更正了技术错误，并阐明以下事实：当存在数据库快照时，不能使文件组在线。

provided by jukuu

If creating a database snapshot fails, the snapshot becomes suspect and must be deleted.

如果创建数据库快照失败，快照便成为可疑快照，必须将其删除。

provided by jukuu

You cannot drop files from a database snapshot.

不能从数据库快照中删除文件。

provided by jukuu

If your application happens to have a high update workload, the database snapshot monitoring may reveal a large number of log pages read.

如果您的应用程序碰巧具有高更新的工作负载，那么数据库快照监控就可以暴露大量的日志页面读。

互联网摘选

In this case, DBCC honors the request by not creating a database snapshot.

在这种情况下，dbcc允许该请求但不创建数据库快照。

provided by jukuu

In this case, a database snapshot cannot be created because of internal restrictions.

在这种情况下，由于内部限制不能创建数据库快照。

provided by jukuu